﻿create PROCEDURE Sync.SP_CommitteesURLs_SelectChanges
@LastRowVersion rowversion,
@FilterdColumn UNIQUEIDENTIFIER
AS 
BEGIN 
	SELECT 
        t.[CommitteeURLID],
		g.[CommitteeName],g.[CommitteeURL],g.[CommitteeID],
		t.IsDeleted,
		t.LastUpdatedDate
	FROM [dbo].[CommitteesURLs] g RIGHT JOIN Sync.CommitteesURLs_Tracking t  
    ON t.CommitteeURLID = g.CommitteeURLID 
	WHERE @LastRowVersion IS NULL OR t.Version > @LastRowVersion
       
    END











